Create Other Staging Table in Staging Database and Populate the Staging Tables - Continued 9
FIPS for Data Sources- Drag
and drop the data Flow task – double click –
1. Drag and drop the Flat Source – Double click and add the Flat
connection manager and select the sheet from the excel to load the data
2. Drag and drop the Conditional Split - Double click and add
condition to remove the Null values
ISNULL(Mnemonic) || ISNULL(RCA_Name) || ISNULL(Name) ||
ISNULL(FIPS)
3. Drag and drop the Derived Column transformation – Add column “Check_Numeric_Value”
(DT_I4)FIPS == (DT_I4)FIPS ? 1 :
0
4. Drag and drop the Derived Column transformation – replace
Check_Numeric_Value
ISNULL(CHECK_NUMERIC_FLAG) ? 0 :1
5. Drag and drop the Conditional Split - Double click and add
condition to remove the Null values
CHECK_NUMERIC_FLAG == 1
6. Drag and drop the Data Conversion and select FIPS and
change the data type to Integer.
7. Drag and drop the OLE DB Destination – double click – add OLE DB
Destination manager – select the destination table and mapping on the column to
the table
FIPS For Final- Drag and drop
the data Flow task – double click –
1. Drag and drop the Flat Source – Double click and add the Flat
connection manager and select the sheet from the excel to load the data
2. Drag and drop the Conditional Split - Double click and add
condition to remove the Null values
ISNULL(Mnemonic)||
ISNULL(CBSA)
3. Drag and drop the Derived Column transformation – Add column “Check_Numeric_Value”
(DT_I4)CBSA == (DT_I4)CBSA ? 1 :
0
4. Drag and drop the Derived Column transformation – replace
Check_Numeric_Value
ISNULL(CHECK_NUMERIC_FLAG) ? 0 :1
5. Drag and drop the Conditional Split - Double click and add
condition to remove the Null values
CHECK_NUMERIC_FLAG == 1
6. Drag and drop the Data Conversion and select CBSA and
change the data type to Integer.
7. Drag and drop the OLE DB Destination – double click – add OLE DB
Destination manager – select the destination table and mapping on the column to
the table
FIPS For Final- Drag and drop
the data Flow task – double click –
1. Drag and drop the Flat Source – Double click and add the Flat
connection manager and select the sheet from the excel to load the data
2. Drag and drop the Data Conversion and select column and
change the data type as in reference picture.
3. Drag and drop the OLE DB Destination – double click – add OLE DB Destination manager – select the destination table and mapping on the column to the table